BEGIN TRANSACTION AddDriver1
	BEGIN TRY
		INSERT INTO [Driver] (DriverNo, FirstName, Surname, DOB, Address, CityId, Postcode, PhoneNumber, EmailAddress, LicenceNo, LicenceExpiryDate, VehicleRegNo, CarSize, OfficeId, AccountNo, AccountSortCode, NIN, DateRegistered, Status)
		VALUES (1, 'Joana', 'Witney', '27-11-1983', '78 Saint James Avenue', '01', 'SA1 9OW', 07765842658, 'joanaw@gmail.com', '12345678945', '07-21', 'BP98 DYK', 'Small', '01', '12345678', '123456', '11112222333', '05/17', 'On a job')
		
		COMMIT TRANSACTION AddDriver1
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddDriver1
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddDriver2
	BEGIN TRY
		INSERT INTO [Driver] (DriverNo, FirstName, Surname, DOB, Address, CityId, Postcode, PhoneNumber, EmailAddress, LicenceNo, LicenceExpiryDate, VehicleRegNo, CarSize, OfficeId, AccountNo, AccountSortCode, NIN, DateRegistered, Status)
		VALUES (2, 'Thomas', 'Witney', '27-1-1983', '78 Saint James Court', '01', 'SA1 9LW', 07765842558, 'thomasw@gmail.com', '12345678954', '08-25', 'BP98 D99', 'Small', '01', '12345698', '123455', '11112222334', '05/16', 'On a job')
		
		COMMIT TRANSACTION AddDriver2
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddDriver2
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddDriver3
	BEGIN TRY
		INSERT INTO [Driver] (DriverNo, FirstName, Surname, DOB, Address, CityId, Postcode, PhoneNumber, EmailAddress, LicenceNo, LicenceExpiryDate, VehicleRegNo, CarSize, OfficeId, AccountNo, AccountSortCode, NIN, DateRegistered, Status)
		VALUES (3, 'Lenard', 'Curry', '7-1-1993', '120 Queensway', '03', 'SW1 1WW', 07765842611, 'Lenardcurry@gmail.com', '12345678911', '05-21', 'LW98 DYK', 'Medium', '03', '12345778', '193456', '99112222333', '05/15', 'On a break')
		
		COMMIT TRANSACTION AddDriver3
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddDriver3
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddDriver4
	BEGIN TRY
		INSERT INTO [Driver] (DriverNo, FirstName, Surname, DOB, Address, CityId, Postcode, PhoneNumber, EmailAddress, LicenceNo, LicenceExpiryDate, VehicleRegNo, CarSize, OfficeId, AccountNo, AccountSortCode, NIN, DateRegistered, Status)
		VALUES (4, 'Lolly', 'Pukery', '01-11-1991', 'Mulberry street', '01', 'SW1 9OW', 07765842622, 'lollyp@gmail.com', '12345678922', '07-29', 'BP98 D22', 'Small', '03', '12345622', '123422', '11112222322', '05/16', 'On a job')
		
		COMMIT TRANSACTION AddDriver4
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddDriver4
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;